EMT Practice Test

1. Question Content...

---

Question1: How often are the Account and Table master keys automatically rotated by Snowflake?

Question2: How many resource monitors can be assigned at the account level?

Question3: What Snowflake role must be granted for a user to create and manage accounts?

Question4: There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production. How can data be easily transferred from the production account to the non-production account?

Question5: What is used to diagnose and troubleshoot network connections to Snowflake?

Question6: What can be used to view warehouse usage over time? (Select Two).

Question7: Which file function generates a Snowflake-hosted file URL to a staged file using the name and relative file path as inputs?

Question8: What happens when a database is cloned?

Question9: What technique does Snowflake use to limit the number of micro-partitions scanned by each query?

Question10: Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

Question11: Which role allows a SnowFlake user to view table-level storage utilization information from the TABLE_STORAGE_METRICS view by the default?

Question12: What are common issues found by using the Query Profile? (Choose two.)

Question13: Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?

Question14: What can the Snowflake SCIM API be used to manage? (Select TWO).

Question15: Why would a Snowflake user decide to use a materialized view instead of a regular view?

Question16: How many credits does a size 3X-Large virtual warehouse consume if it runs continuously for 2 hours?

Question17: How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?

Question18: In Snowflake, the use of federated authentication enables which Single Sign-On (SSO) workflow activities? (Select TWO).

Question19: A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

Question20: How long is the Fail-safe period for temporary and transient tables?

Question21: Which data type can store more than one type of data structure?

Question22: For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?

Question23: Snowflake's hierarchical key mode includes which keys? (Select TWO).

Question24: Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?

Question25: Which Snowflake table supports unstructured data?

Question26: A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?

Question27: Which command can be used to load data files into a Snowflake stage?

Question28: Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

Question29: A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.
Which CREATE object statement will automatically assign the TABLE_A tag to a target object?

Question30: When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?

Question31: Which role has the ability to create a share from a shared database by default?

Question32: What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?

Question33: By definition, a secure view is exposed only to users with what privilege?

Question34: Which DDL/DML operation is allowed on an inbound data share?

Question35: User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in the same Snowflake account, wants to view the result set of the query executed by User1 using the Snowsight query history.
What will happen if User2 tries to access the query history?

Question36: Which file function generates a SnowFlake-hosted URL that must be authenticated when used?

Question37: A user wants to access stored in a stage without authenticating into Snowflake.
Which type of URL should be used?

Question38: When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileged to the stage or to issue access token?

Question39: Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

Question40: Which Snowflake URL type is used by directory tables?

Question41: True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

Question42: When snaring data in Snowflake. what privileges does a Provider need to grant along with a share? (Select TWO).

Question43: When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

Question44: Which Snowflake objects can be restored using Time Travel? (Select VNO).

Question45: Where can a user find and review the failed logins of a specific user for the past 30 days?

Question46: Which of the following objects can be shared through secure data sharing?

Question47: How would a user run a multi-cluster warehouse in maximized mode?

Question48: Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

Question49: Which Snowflake technique can be used to improve the performance of a query?

Question50: Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?

Question51: What is true about sharing data in Snowflake? (Choose two.)

Question52: If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

Question53: How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?

Question54: What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

Question55: Which formats does Snowflake store unstructured data in? (Choose two.)

Question56: What features does Snowflake Time Travel enable?

Question57: What information is found within the Statistic output in the Query Profile Overview?

Question58: Which of the following statements describe features of Snowflake data caching? (Choose two.)

Question59: How does the Snowflake search optimization service improve query performance?

Question60: How long is a query visible in the Query History page in the Snowflake Web Interface (Ul)?

Question61: What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?

Question62: Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

Question63: What criteria does Snowflake use to determine the current role when initiating a session? (Select TWO).

Question64: Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?

Question65: What is the MAXIMUM number of clusters that can be provisioned with a multi-cluster virtual warehouse?

Question66: Which role in Snowflake allows a user to enable replication for multiple accounts?

Question67: During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

Question68: Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

Question69: Which native data types are used for storing semi-structured data in Snowflake? (Select TWO)

Question70: Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

Question71: Which cache type is used to cache data output from SQL queries?

Question72: What is a limitation of a Materialized View?

Question73: Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

Question74: Which user preferences can be set for a user profile in Snowsight? (Select TWO).

Question75: If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

Question76: How does Snowflake define i1s approach to Discretionary Access Control (DAC)?

Question77: What are the benefits of the replication feature in Snowflake? (Select TWO).

Question78: What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

Question79: What COPY INTO SQL command should be used to unload data into multiple files?

Question80: How can a Snowflake user access a JSON object, given the following table? (Select TWO).

Question81: What is a responsibility of Snowflake's virtual warehouses?

Question82: Which statement is true about running tasks in Snowflake?

Question83: What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

Question84: What column type does a Kafka connector store formatted information in a single column?

Question85: Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

Question86: How are serverless features billed?

Question87: What type of account can be used to share data with a consumer who does have a Snowflake account?

Question88: Which command can be used to list all the file formats for which a user has access privileges?

Question89: True or False: Fail-safe can be disabled within a Snowflake account.

Question90: Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

Question91: Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

Question92: A permanent table and temporary table have the same name, TBLI, in a schema.
What will happen if a user executes select * from TBLI;?

Question93: What happens when a cloned table is replicated to a secondary database? (Select TWO)

Question94: How does the search optimization service help Snowflake users improve query performance?

Question95: Which Snowflake layer is always leveraged when accessing a query from the result cache?

Question96: What is the difference between a stored procedure and a User-Defined Function (UDF)?

Question97: Which of the following describes external functions in Snowflake?

Question98: Which file formats are supported for unloading data from Snowflake? (Choose two.)

Question99: Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?

Question100: The Snowflake Search Optimization Services supports improved performance of which kind of query?

Question101: Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

Question102: Which minimum Snowflake edition allows for a dedicated metadata store?

Question103: Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

Question104: Where would a Snowflake user find information about query activity from 90 days ago?

Question105: What is the minimum Snowflake edition required to use Dynamic Data Masking?

Question106: How long is Snowpipe data load history retained?

Question107: What can a Snowflake user do in the Admin area of Snowsight?

Question108: Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

Question109: Which of the following statements apply to Snowflake in terms of security? (Choose two.)

Question110: How are network policies defined in Snowflake?

Question111: Which use case does the search optimization service support?

Question112: Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

Question113: In which use cases does Snowflake apply egress charges?

Question114: What operations can be performed while loading a simple CSV file into a Snowflake table using the COPY INTO command? (Select TWO).

Question115: What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

Question116: How can a Snowflake user post-process the result of SHOW FILE FORMATS?

Question117: Which command is used to unload data from a Snowflake table into a file in a stage?

Question118: Which Snowflake feature records changes mace to a table so actions can be taken using that change data capture?

Question119: How can a user change which columns are referenced in a view?

Question120: Which command sets the Virtual Warehouse for a session?

Question121: A user has a standard multi-cluster warehouse auto-scaling policy in place.
Which condition will trigger a cluster to shut-down?

Question122: If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?

Question123: Which command can be used to load data into an internal stage?

Question124: Which system_defined, read-only view display information on column lineage that specifies how data flows from source to target in a SQL write operation?

Question125: Which Snowflake feature is used for both querying and restoring data?

Question126: Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

Question127: A user is preparing to load data from an external stage
Which practice will provide the MOST efficient loading performance?

Question128: What is the only supported character set for loading and unloading data from all supported file formats?

Question129: What does Snowflake recommend a user do if they need to connect to Snowflake with a tool or technology mat is not listed in Snowflake partner ecosystem?

Question130: What actions will prevent leveraging of the ResultSet cache? (Choose two.)

Question131: What privilege should a user be granted to change permissions for new objects in a managed access schema?

Question132: How should a Snowflake use' configure a virtual warehouse to be in Maximized mode''

Question133: Which feature is only available in the Enterprise or higher editions of Snowflake?

Question134: Which statement about billing applies to Snowflake credits?

Question135: Which of the following significantly improves the performance of selective point lookup queries on a table?

Question136: What is the following SQL command used for?
Select * from table(validate(t1, job_id => '_last'));

Question137: Which TABLE function helps to convert semi-structured data to a relational representation?

Question138: A Snowflake user needs to share unstructured data from an internal stage to a reporting tool that does not have Snowflake access.
Which file function should be used?

Question139: How many days is load history for Snowpipe retained?

Question140: What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

Question141: What are characteristics of transient tables in Snowflake? (Select TWO).

Question142: User-level network policies can be created by which of the following roles? (Select TWO).

Question143: A user wants to upload a file to an internal Snowflake stage using a put command.
Which tools and or connectors could be used to execute this command? (Select TWO).

Question144: Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

Question145: Which services does the Snowflake Cloud Services layer manage? (Select TWO).

Question146: Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

Question147: If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?

Question148: How can a Snowflake user optimize query performance in Snowflake? (Select TWO).

Question149: Which of the following are benefits of micro-partitioning? (Select TWO)

Question150: A Snowflake user wants to temporarily bypass a network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY.
What should they do?

Question151: How does Snowflake describe its unique architecture?

Question152: When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).

Question153: How does Snowflake handle the bulk unloading of data into single or multiple files?

Question154: What are valid sub-clauses to the OVER clause for a window function? (Select TWO).

Question155: How can a Snowflake user validate data that is unloaded using the COPY INTO <location> command?

Question156: A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?

Question157: Which service or feature in Snowflake is used to improve the performance of certain types of lookup and analytical queries that use an extensive set of WHERE conditions?

Question158: What is the default file size when unloading data from Snowflake using the COPY command?

Question159: What is a best practice after creating a custom role?

Question160: What are characteristic of Snowsight worksheet? (Select TWO.)

Question161: Which of the following describes the Snowflake Cloud Services layer?

Question162: Which Snowflake tool would be BEST to troubleshoot network connectivity?

Question163: The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

Question164: A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.
How does Snowflake recommend maximizing the load performance?

Question165: Which system_defined Snowflake role has permission to rename an account and specify whether the original URL can be used to access the renamed account?

Question166: What is it called when a customer managed key is combined with a Snowflake managed key to create a composite key for encryption?

Question167: Which command is used to lake away staged files from a Snowflake stage after a successful data ingestion?

Question168: What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

Question169: Which parameter prevents streams on tables from becoming stale?

Question170: What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

Question171: Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

Question172: What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?

Question173: How does Snowflake reorganize data when it is loaded? (Select TWO).

Question174: What SnowFlake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?

Question175: How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

Question176: Which of the following are characteristics of security in Snowflake?

Question177: The VALIDATE table function has which parameter as an input argument for a Snowflake user?

Question178: What can a Snowflake user do in the Activity section in Snowsight?

Question179: The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

Question180: What does Snowflake recommend for a user assigned the ACCOUNTADMIN role?

Question181: What affects whether the query results cache can be used?

Question182: What activities can a user with the ORGADMIN role perform? (Select TWO).

Question183: Where is Snowflake metadata stored?

Question184: Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

Question185: Where would a Snowflake user find information about query activity from 90 days ago?

Question186: By default, which Snowflake role is required to create a share?

Question187: What computer language can be selected when creating User-Defined Functions (UDFs) using the Snowpark API?

Question188: True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

Question189: If a virtual warehouse runs for 61 seconds, shut down, and then restart and runs for 30 seconds, for how many seconds is it billed?

Question190: How would you determine the size of the virtual warehouse used for a task?

Question191: Which function is used to convert rows in a relational table to a single VARIANT column?

Question192: Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

Question193: Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

Question194: Which function should be used to insert JSON format string data inot a VARIANT field?

Question195: True or False: A Virtual Warehouse can be resized while suspended.

Question196: How would a user execute a series of SQL statements using a task?

Question197: Which command can be used to stage local files from which Snowflake interface?

Question198: Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?

Question199: What are ways to create and manage data shares in Snowflake? (Select TWO)

Question200: What are the main differences between the account usage views and the information schema views? (Select TWO).

Question201: In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

Question202: What data is stored in the Snowflake storage layer? (Select TWO).

Question203: Which features make up Snowflake's column level security? (Select TWO).

Question204: What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

Question205: What happens to historical data when the retention period for an object ends?

Question206: What can a user win a reader account do in Snowflake?

Question207: What is a non-configurable feature that provides historical data that Snowflake may recover during a 7-day period?

Question208: A user has an application that writes a new Tile to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?

Question209: Which data types optimally store semi-structured data? (Select TWO).

Question210: Which Snowflake partner specializes in data catalog solutions?

Question211: A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?

Question212: Which statement accurately describes how a virtual warehouse functions?

Question213: How many network policies can be assigned to an account or specific user at a time?

Question214: A JSON object is loaded into a column named data using a Snowflake variant datatype. The root node of the object is BIKE. The child attribute for this root node is BIKEID.
Which statement will allow the user to access BIKEID?

Question215: Which of the following can be executed/called with Snowpipe?

Question216: Which file format will keep floating-point numbers from being truncated when data is unloaded?

Question217: Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

Question218: Which statement describes how Snowflake supports reader accounts?

Question219: A user needs to create a materialized view in the schema MYDB.MYSCHEM A.
Which statements will provide this access?

Question220: What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

Question221: Which privilege is required to use the search optimization service in Snowflake?

Question222: How can a data provider ensure that a data consumer is going to have access to the required objects?

Question223: What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?

Question224: A user has semi-structured data to load into Snowflake but is not sure what types of operations will need to be performed on the dat a. Based on this situation, what type of column does Snowflake recommend be used?

Question225: Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

Question226: Which statement accurately describes Snowflake's architecture?

Question227: In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

Question228: What are value types that a VARIANT column can store? (Select TWO)

Question229: What is the minimum Snowflake edition required to create a materialized view?

Question230: Which view in SNOWFLAKE.ACCOUNT_USAGE shows from which IP address a user connected to Snowflak?

Question231: Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

Question232: A user wants to add additional privileges to the system-defined roles for their virtual warehouse. How does Snowflake recommend they accomplish this?

Question233: What is the purpose of using the OBJECT_CONSTRUCT function with me COPY INTO command?